
  ___  ____  ____  ____  ____ (R)
 /__    /   ____/   /   ____/
___/   /   /___/   /   /___/   15.1   Copyright 1985-2017 StataCorp LLC
  Statistics/Data Analysis            StataCorp
                                      4905 Lakeway Drive
     MP - Parallel Edition            College Station, Texas 77845 USA
                                      800-STATA-PC        http://www.stata.com
                                      979-696-4600        stata@stata.com
                                      979-696-4601 (fax)

32-user 64-core Stata network perpetual license:
       Serial number:  501506200495
         Licensed to:  Harvard-MIT Data Center
                       Cambridge, MA

Notes:
      1.  Stata is running in batch mode.
      2.  Unicode is supported; see help unicode_advice.
      3.  More than 2 billion observations are allowed; see help obs_advice.
      4.  Maximum number of variables is set to 5000; see help set_maxvar.

. do "dofiles/7_Table_A2.do" 

. /*
> Replication files for "Housing Discrimination and the Pollution Exposure Gap 
> in the United States" 
> */
. 
. 
. clear all

. set matsize 11000

. 
. use "../stores/toxic_discrimination_data.dta"

. 
. 
. keep if sample==1
(801 observations deleted)

. 
. loc quartiles 3

. 
. 
. *****************************************************************************
> *******************
. * Columns (1)-(3)
. *****************************************************************************
> *******************
. 
. decode type, gen(ap_type)

. table ap_type

-------------------------------
  Type of Property |      Freq.
-------------------+-----------
         Apartment |        909
      Multi-Family |      3,543
Single-Family Home |      1,134
-------------------------------

. gen SFH=(ap_type=="Single-Family Home")

. gen Apt=(ap_type=="Apartment")

. gen Multi_Fam=(ap_type=="Multi-Family")

. gen Other=(ap_type=="")

. 
. replace scorecancer=scorecancer/pop
(6,723 real changes made)

. replace scorenoncancer=scorenoncancer/pop
(6,723 real changes made)

. 
. lab var SFH "Single Family Home"

. lab var Apt "Apartment"

. lab var Multi_Fam "Multi Family"

. lab var Other "Other Bldg. Type"

. 
. matrix define B=J(38,`quartiles',.)

. 
. 
. *ssc install winsor2
. winsor2 rent, suffix(_w) cuts(0 99)

. 
. 
. replace toxconc=toxconc/1000
(6,723 real changes made)

. replace rent_w=rent_w/1000
variable rent_w was long now double
(6,696 real changes made)

. 
. 
. loc l = 1

. foreach i of varlist toxconc scorecancer scorenoncancer rent_w SFH  Apt Multi
> _Fam Other bedroom_max bathroom_max sqft assault groceries hispanicsh blacksh
> are whiteshare povrate  unemployed college  {
  2. 
.         forvalues j = 1/`quartiles'{
  3.                 
.         sum  `i' if quartileZIP_property==`j'+1
  4.                 
.         matrix B[`l',`j'] = r(mean)
  5.         matrix B[`l'+1,`j'] = r(sd)
  6. 
.         
.         
.         }
  7. loc l=`l'+2
  8. }

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     toxconc |      1,800      11.903    11.98691   .0543875    53.9013

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     toxconc |      3,342    19.73042    23.09097   .0512444    101.388

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     toxconc |      1,581    30.60408    46.26231   .0663728    319.803

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
 scorecancer |      1,800    5.759488    9.591149    .000452   91.37092

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
 scorecancer |      3,342    7.871335    11.31004   .0000633   99.55391

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
 scorecancer |      1,581    10.36103    15.15743   .0017599   91.78092

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
scorenonca~r |      1,800    3.230633    10.36848   .0000286   91.64632

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
scorenonca~r |      3,342    5.790969    13.04062   4.52e-06   62.43322

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
scorenonca~r |      1,581    6.272869    12.17005   .0001229   102.7732

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
      rent_w |      1,797    2.234584    2.435612       .475       13.5

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
      rent_w |      3,318    1.703077    1.335086       .295       13.5

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
      rent_w |      1,581     1.83993    1.549374       .425       13.5

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
         SFH |      1,800    .2133333    .4097749          0          1

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
         SFH |      3,342    .1705566    .3761773          0          1

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
         SFH |      1,581     .113852    .3177319          0          1

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
         Apt |      1,800    .1283333    .3345535          0          1

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
         Apt |      3,342    .1310592    .3375156          0          1

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
         Apt |      1,581    .1518027     .358943          0          1

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
   Multi_Fam |      1,800         .49    .5000389          0          1

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
   Multi_Fam |      3,342    .5233393    .4995297          0          1

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
   Multi_Fam |      1,581    .5768501    .4942151          0          1

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
       Other |      1,800    .1683333     .374266          0          1

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
       Other |      3,342    .1750449    .3800624          0          1

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
       Other |      1,581    .1574953    .3643823          0          1

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
 bedroom_max |      1,746    2.434708    1.128697          1          7

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
 bedroom_max |      3,201    2.267104    .9811705          1          6

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
 bedroom_max |      1,542    2.330739    .9336603          1          8

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
bathroom_max |      1,788    1.540268    .7643793          1          7

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
bathroom_max |      3,336     1.42536    .6297032          1          5

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
bathroom_max |      1,575    1.484762    .6399622          1          5

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
        sqft |      1,800    716.3267    730.2088          1       2218

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
        sqft |      3,342    749.1876    759.0892          1       2220

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
        sqft |      1,581    694.3302    756.2655          1       2217

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     assault |      1,758    220.5461    319.9788          0       1251

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     assault |      3,300    183.7573    272.1901          0       1251

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     assault |      1,581    253.2922    387.8084          0       1251

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
   groceries |      1,794    31.92642    44.01103          0        229

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
   groceries |      3,330    25.14414    22.79094          0        157

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
   groceries |      1,581    28.43833    35.53523          1        250

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
hispanicsh~e |      1,800    .1012919     .162729          0   .9521359

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
hispanicsh~e |      3,342     .131375    .2083886          0          1

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
hispanicsh~e |      1,581    .0894059     .130478          0          1

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
  blackshare |      1,800    .2078718     .271233          0          1

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
  blackshare |      3,342    .2334781    .2859929          0          1

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
  blackshare |      1,581    .2992353    .3371832          0          1

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
  whiteshare |      1,800    .6871604     .273906          0          1

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
  whiteshare |      3,342    .6434212    .2704989          0          1

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
  whiteshare |      1,581    .6118465    .3156248          0          1

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     povrate |      1,800    .2375636      .20575          0   .8825911

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     povrate |      3,342    .2908063    .2191622          0          1

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     povrate |      1,581    .2735621    .2278312   .0100334   .9004038

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
  unemployed |      1,800    .0837657    .0785059          0   .3930818

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
  unemployed |      3,339    .0872576    .0826514          0   .6242775

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
  unemployed |      1,581     .093054    .0993705          0    .515625

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     college |      1,800     .286306    .1548672          0          1

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     college |      3,342    .2638532    .1485241          0          1

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     college |      1,581    .2813275    .1815724          0          1

. 
. mat list B

B[38,3]
            c1         c2         c3
 r1     11.903  19.730422  30.604076
 r2  11.986913   23.09097  46.262315
 r3  5.7594881  7.8713349  10.361032
 r4  9.5911486  11.310039  15.157425
 r5  3.2306335  5.7909687  6.2728691
 r6  10.368481  13.040619  12.170054
 r7  2.2345843  1.7030769  1.8399298
 r8  2.4356118  1.3350862  1.5493741
 r9  .21333333  .17055655  .11385199
r10  .40977495   .3761773  .31773192
r11  .12833333  .13105925  .15180266
r12  .33455354  .33751564  .35894304
r13        .49  .52333932  .57685009
r14  .50003891  .49952972  .49421509
r15  .16833333  .17504488  .15749526
r16    .374266  .38006236  .36438233
r17  2.4347079   2.267104  2.3307393
r18  1.1286975  .98117055  .93366031
r19  1.5402685  1.4253597  1.4847619
r20  .76437929  .62970319  .63996222
r21  716.32667  749.18761  694.33017
r22  730.20883  759.08924  756.26554
r23  220.54608  183.75727  253.29222
r24  319.97884   272.1901  387.80842
r25  31.926421  25.144144   28.43833
r26  44.011028  22.790943  35.535232
r27  .10129186  .13137504  .08940593
r28  .16272905  .20838862  .13047796
r29  .20787178  .23347812  .29923531
r30  .27123303  .28599289  .33718324
r31  .68716035  .64342119  .61184649
r32  .27390605   .2704989  .31562476
r33  .23756359   .2908063   .2735621
r34  .20574999  .21916222  .22783123
r35  .08376566  .08725758  .09305401
r36   .0785059  .08265143  .09937052
r37  .28630596  .26385315   .2813275
r38  .15486721   .1485241  .18157245

. 
. preserve

. clear

. svmat B
number of observations will be reset to 38
Press any key to continue, or Break to abort
number of observations (_N) was 0, now 38

. 
. 
. forvalues j = 1/`quartiles'{
  2.         rename B`j' Q`j'
  3.         format %9.2fc Q`j'
  4. }

. 
. export delimited using "../views/descriptive_RSEI.csv", replace
(note: file ../views/descriptive_RSEI.csv not found)
file ../views/descriptive_RSEI.csv saved

. restore

. 
. *****************************************************************************
> *******************
. * Columns (4)-(5)
. *****************************************************************************
> *******************
. 
. 
. tab quartileZIP_property, gen(Q)

            Quartile Within Zip Toxic |
                        Concentration |      Freq.     Percent        Cum.
--------------------------------------+-----------------------------------
  0-25 Within Zip Toxic Concentration |      1,800       26.77       26.77
 25-75 Within Zip Toxic Concentration |      3,342       49.71       76.48
75-100 Within Zip Toxic Concentration |      1,581       23.52      100.00
--------------------------------------+-----------------------------------
                                Total |      6,723      100.00

. 
. loc quartiles 3

. matrix define B=J(38,`quartiles',.)

. 
. 
. loc l = 1

. *
. foreach i of varlist toxconc scorecancer scorenoncancer rent_w SFH  Apt Multi
> _Fam Other bedroom_max bathroom_max sqft assault groceries hispanicsh blacksh
> are whiteshare povrate  unemployed college  {
  2.         
.                 
.         reg `i' Q2 Q3 i.Zip_Code
  3.                 
.         matrix B[`l',1] = _b[_cons]
  4.         matrix B[`l'+1,1] = _se[_cons]
  5.         
.         matrix B[`l',2] = _b[Q2]
  6.         matrix B[`l'+1,2] = _se[Q2]
  7.         matrix B[`l',3] = _b[Q3]
  8.         matrix B[`l'+1,3] = _se[Q3]
  9.         
. 
.         
. loc l=`l'+2
 10. }

      Source |       SS           df       MS      Number of obs   =     6,723
-------------+----------------------------------   F(15, 6707)     =    969.93
       Model |  3913222.37        15  260881.491   Prob > F        =    0.0000
    Residual |  1803968.92     6,707  268.968082   R-squared       =    0.6845
-------------+----------------------------------   Adj R-squared   =    0.6838
       Total |  5717191.29     6,722  850.519383   Root MSE        =      16.4

------------------------------------------------------------------------------
     toxconc |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
          Q2 |   2.786915   .4947659     5.63   0.000     1.817017    3.756813
          Q3 |    15.9089   .5688277    27.97   0.000     14.79382    17.02398
             |
    Zip_Code |
          3  |   7.993362   1.702411     4.70   0.000     4.656094    11.33063
          4  |   9.516866   1.789613     5.32   0.000     6.008656    13.02508
          5  |   30.55973   1.390901    21.97   0.000     27.83312    33.28633
          6  |   5.594773   1.999793     2.80   0.005     1.674543    9.515003
          8  |   14.26174   1.557575     9.16   0.000     11.20839    17.31508
          9  |   4.156903   1.491044     2.79   0.005     1.233982    7.079823
         10  |   80.62328   1.476724    54.60   0.000     77.72843    83.51812
         11  |   6.275505   1.558125     4.03   0.000     3.221086    9.329925
         12  |   5.050468   1.440709     3.51   0.000      2.22622    7.874715
         13  |   31.40583    1.46037    21.51   0.000     28.54304    34.26862
         15  |   .6955047   1.580642     0.44   0.660    -2.403057    3.794066
         17  |   3.861177   1.791548     2.16   0.031     .3491733    7.373182
         18  |   2.090342   1.719968     1.22   0.224    -1.281342    5.462026
             |
       _cons |  -6.825941   1.342327    -5.09   0.000    -9.457327   -4.194554
------------------------------------------------------------------------------

      Source |       SS           df       MS      Number of obs   =     6,723
-------------+----------------------------------   F(15, 6707)     =    703.68
       Model |  595374.515        15  39691.6343   Prob > F        =    0.0000
    Residual |  378312.527     6,707   56.405625   R-squared       =    0.6115
-------------+----------------------------------   Adj R-squared   =    0.6106
       Total |  973687.041     6,722  144.850795   Root MSE        =    7.5104

------------------------------------------------------------------------------
 scorecancer |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
          Q2 |   1.211808   .2265743     5.35   0.000     .7676502    1.655965
          Q3 |   2.712104   .2604903    10.41   0.000      2.20146    3.222747
             |
    Zip_Code |
          3  |   7.233014   .7796064     9.28   0.000     5.704737     8.76129
          4  |   3.102655   .8195396     3.79   0.000     1.496097    4.709213
          5  |   1.612002   .6369524     2.53   0.011     .3633731    2.860631
          6  |  -1.713289     .91579    -1.87   0.061    -3.508528    .0819504
          8  |   10.73856   .7132797    15.06   0.000     9.340306    12.13682
          9  |  -2.267255   .6828124    -3.32   0.001    -3.605784   -.9287256
         10  |   21.69604   .6762544    32.08   0.000     20.37036    23.02171
         11  |   .4859182   .7135313     0.68   0.496    -.9128299    1.884666
         12  |  -.8242565   .6597617    -1.25   0.212    -2.117599     .469086
         13  |   23.06707   .6687654    34.49   0.000     21.75608    24.37806
         15  |  -2.639107   .7238432    -3.65   0.000     -4.05807   -1.220144
         17  |  -2.408644   .8204259    -2.94   0.003    -4.016939   -.8003483
         18  |  -2.305719   .7876463    -2.93   0.003    -3.849756   -.7616818
             |
       _cons |   1.231555   .6147083     2.00   0.045     .0265313    2.436578
------------------------------------------------------------------------------

      Source |       SS           df       MS      Number of obs   =     6,723
-------------+----------------------------------   F(15, 6707)     =    433.07
       Model |   494737.88        15  32982.5253   Prob > F        =    0.0000
    Residual |  510807.144     6,707  76.1603017   R-squared       =    0.4920
-------------+----------------------------------   Adj R-squared   =    0.4909
       Total |  1005545.02     6,722  149.590155   Root MSE        =     8.727

------------------------------------------------------------------------------
scorenonca~r |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
          Q2 |   3.588616   .2632775    13.63   0.000     3.072509    4.104724
          Q3 |   4.197974   .3026876    13.87   0.000      3.60461    4.791338
             |
    Zip_Code |
          3  |   1.020453   .9058963     1.13   0.260    -.7553913    2.796298
          4  |   4.515256   .9522984     4.74   0.000     2.648449    6.382064
          5  |   19.42833   .7401336    26.25   0.000     17.97744    20.87923
          6  |  -1.027271   1.064141    -0.97   0.334    -3.113325    1.058783
          8  |  -.6303002   .8288253    -0.76   0.447    -2.255061    .9944607
          9  |  -1.087327   .7934225    -1.37   0.171    -2.642687    .4680333
         10  |  -1.568247   .7858021    -2.00   0.046    -3.108669   -.0278255
         11  |  -.6921559   .8291177    -0.83   0.404     -2.31749    .9331781
         12  |  -.9817212   .7666378    -1.28   0.200    -2.484575    .5211324
         13  |   .5837174      .7771     0.75   0.453    -.9396454     2.10708
         15  |  -1.381926   .8410999    -1.64   0.100    -3.030749    .2668972
         17  |   -1.83847   .9533283    -1.93   0.054    -3.707296    .0303567
         18  |  -.6715473   .9152387    -0.73   0.463    -2.465706    1.122611
             |
       _cons |  -1.655265   .7142861    -2.32   0.021    -3.055493   -.2550378
------------------------------------------------------------------------------

      Source |       SS           df       MS      Number of obs   =     6,696
-------------+----------------------------------   F(15, 6680)     =    413.43
       Model |  9961.61363        15  664.107575   Prob > F        =    0.0000
    Residual |  10730.2239     6,680  1.60632095   R-squared       =    0.4814
-------------+----------------------------------   Adj R-squared   =    0.4803
       Total |  20691.8376     6,695  3.09064041   Root MSE        =    1.2674

------------------------------------------------------------------------------
      rent_w |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
          Q2 |  -.3128947    .038309    -8.17   0.000    -.3879925   -.2377969
          Q3 |  -.2788914   .0439744    -6.34   0.000    -.3650952   -.1926876
             |
    Zip_Code |
          3  |  -3.325052   .1315657   -25.27   0.000    -3.582962   -3.067141
          4  |  -3.382072   .1383039   -24.45   0.000    -3.653192   -3.110952
          5  |   -2.97456   .1075053   -27.67   0.000    -3.185305   -2.763815
          6  |  -3.141039   .1545509   -20.32   0.000    -3.444008   -2.838069
          8  |  -3.659299   .1203703   -30.40   0.000    -3.895263   -3.423334
          9  |  -3.920742   .1152334   -34.02   0.000    -4.146636   -3.694848
         10  |  -3.787364    .114164   -33.17   0.000    -4.011162   -3.563566
         11  |   -3.72026   .1204152   -30.90   0.000    -3.956312   -3.484208
         12  |  -4.281445   .1114962   -38.40   0.000    -4.500014   -4.062877
         13  |  -4.020429   .1128604   -35.62   0.000    -4.241671   -3.799187
         15  |  -4.295624   .1221559   -35.17   0.000    -4.535089    -4.05616
         17  |  -1.992733   .1384639   -14.39   0.000    -2.264166   -1.721299
         18  |   1.646216   .1329206    12.38   0.000     1.385649    1.906783
             |
       _cons |   5.450138   .1037364    52.54   0.000     5.246782    5.653494
------------------------------------------------------------------------------

      Source |       SS           df       MS      Number of obs   =     6,723
-------------+----------------------------------   F(15, 6707)     =     62.07
       Model |  114.921025        15  7.66140165   Prob > F        =    0.0000
    Residual |  827.801867     6,707  .123423567   R-squared       =    0.1219
-------------+----------------------------------   Adj R-squared   =    0.1199
       Total |  942.722892     6,722  .140244405   Root MSE        =    .35132

------------------------------------------------------------------------------
         SFH |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
          Q2 |  -.0486028   .0105986    -4.59   0.000    -.0693795   -.0278262
          Q3 |  -.1017937   .0121851    -8.35   0.000    -.1256804    -.077907
             |
    Zip_Code |
          3  |   .1505006   .0364681     4.13   0.000     .0790116    .2219897
          4  |    .130661   .0383361     3.41   0.001     .0555101    .2058119
          5  |    .138885   .0297951     4.66   0.000     .0804772    .1972929
          6  |   .3201417   .0428384     7.47   0.000     .2361647    .4041187
          8  |   .2076708   .0333655     6.22   0.000     .1422638    .2730778
          9  |    .336995   .0319403    10.55   0.000     .2743818    .3996081
         10  |   .1324125   .0316335     4.19   0.000     .0704006    .1944243
         11  |   .0731056   .0333773     2.19   0.029     .0076755    .1385356
         12  |   .1500139   .0308621     4.86   0.000     .0895144    .2105133
         13  |   .0115448   .0312832     0.37   0.712    -.0497803    .0728698
         15  |   .5294911   .0338596    15.64   0.000     .4631155    .5958668
         17  |  -.0011341   .0383775    -0.03   0.976    -.0763663    .0740981
         18  |    .303431   .0368442     8.24   0.000     .2312046    .3756573
             |
       _cons |   .0498739   .0287546     1.73   0.083    -.0064942     .106242
------------------------------------------------------------------------------

      Source |       SS           df       MS      Number of obs   =     6,723
-------------+----------------------------------   F(15, 6707)     =     41.30
       Model |  66.4758172        15  4.43172115   Prob > F        =    0.0000
    Residual |  719.620568     6,707  .107293957   R-squared       =    0.0846
-------------+----------------------------------   Adj R-squared   =    0.0825
       Total |  786.096386     6,722  .116943824   Root MSE        =    .32756

------------------------------------------------------------------------------
         Apt |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
          Q2 |   -.008148   .0098818    -0.82   0.410    -.0275195    .0112235
          Q3 |   .0281602    .011361     2.48   0.013     .0058889    .0504314
             |
    Zip_Code |
          3  |   .0612645   .0340018     1.80   0.072    -.0053898    .1279188
          4  |   .0572732   .0357434     1.60   0.109    -.0127953    .1273417
          5  |    .069013   .0277801     2.48   0.013     .0145552    .1234708
          6  |   .0389262   .0399413     0.97   0.330    -.0393714    .1172239
          8  |   .2826596    .031109     9.09   0.000     .2216761    .3436432
          9  |   .2856386   .0297802     9.59   0.000       .22726    .3440173
         10  |   .2317293   .0294942     7.86   0.000     .1739113    .2895472
         11  |   .2641506     .03112     8.49   0.000     .2031455    .3251556
         12  |   .2306175   .0287749     8.01   0.000     .1742096    .2870254
         13  |   .0290716   .0291676     1.00   0.319    -.0281061    .0862493
         15  |   .1072093   .0315697     3.40   0.001     .0453226    .1690961
         17  |   .1246804   .0357821     3.48   0.000     .0545361    .1948247
         18  |    .036532   .0343524     1.06   0.288    -.0308097    .1038737
             |
       _cons |  -.0133819   .0268099    -0.50   0.618    -.0659378    .0391741
------------------------------------------------------------------------------

      Source |       SS           df       MS      Number of obs   =     6,723
-------------+----------------------------------   F(15, 6707)     =    124.99
       Model |  366.108607        15  24.4072405   Prob > F        =    0.0000
    Residual |  1309.74146     6,707  .195279776   R-squared       =    0.2185
-------------+----------------------------------   Adj R-squared   =    0.2167
       Total |  1675.85007     6,722  .249308252   Root MSE        =     .4419

------------------------------------------------------------------------------
   Multi_Fam |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
          Q2 |   .0241048   .0133315     1.81   0.071    -.0020291    .0502388
          Q3 |   .0587751   .0153271     3.83   0.000     .0287292     .088821
             |
    Zip_Code |
          3  |  -.4590967   .0458715   -10.01   0.000    -.5490194    -.369174
          4  |  -.7380627   .0482211   -15.31   0.000    -.8325915    -.643534
          5  |  -.7092095   .0374778   -18.92   0.000    -.7826779    -.635741
          6  |  -.5163062   .0538844    -9.58   0.000    -.6219369   -.4106756
          8  |  -.5566294   .0419689   -13.26   0.000    -.6389018   -.4743571
          9  |  -.5996653   .0401762   -14.93   0.000    -.6784235   -.5209072
         10  |  -.3322721   .0397903    -8.35   0.000    -.4102738   -.2542704
         11  |  -.3370663   .0419837    -8.03   0.000    -.4193677    -.254765
         12  |  -.3637571   .0388199    -9.37   0.000    -.4398564   -.2876577
         13  |  -.0233137   .0393497    -0.59   0.554    -.1004516    .0538241
         15  |  -.6374662   .0425904   -14.97   0.000    -.7209569   -.5539754
         17  |  -.0958716   .0482733    -1.99   0.047    -.1905026   -.0012407
         18  |   -.367032   .0463446    -7.92   0.000     -.457882   -.2761819
             |
       _cons |   .9520484    .036169    26.32   0.000     .8811457    1.022951
------------------------------------------------------------------------------

      Source |       SS           df       MS      Number of obs   =     6,723
-------------+----------------------------------   F(15, 6707)     =    253.35
       Model |  341.681727        15  22.7787818   Prob > F        =    0.0000
    Residual |  603.027777     6,707   .08991021   R-squared       =    0.3617
-------------+----------------------------------   Adj R-squared   =    0.3603
       Total |  944.709505     6,722  .140539944   Root MSE        =    .29985

------------------------------------------------------------------------------
       Other |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
          Q2 |    .032646   .0090459     3.61   0.000     .0149131    .0503789
          Q3 |   .0148584      .0104     1.43   0.153     -.005529    .0352458
             |
    Zip_Code |
          3  |   .2473316   .0311257     7.95   0.000     .1863154    .3083478
          4  |   .5501286     .03272    16.81   0.000      .485987    .6142702
          5  |   .5013114   .0254302    19.71   0.000     .4514601    .5511627
          6  |   .1572383   .0365628     4.30   0.000     .0855637     .228913
          8  |    .066299   .0284776     2.33   0.020     .0104739    .1221242
          9  |  -.0229683   .0272612    -0.84   0.400    -.0764088    .0304723
         10  |  -.0318696   .0269994    -1.18   0.238    -.0847969    .0210577
         11  |  -.0001898   .0284876    -0.01   0.995    -.0560346     .055655
         12  |  -.0168742   .0263409    -0.64   0.522    -.0685107    .0347623
         13  |  -.0173026   .0267004    -0.65   0.517    -.0696438    .0350385
         15  |   .0007657   .0288993     0.03   0.979    -.0558861    .0574176
         17  |  -.0276747   .0327554    -0.84   0.398    -.0918856    .0365363
         18  |    .027069   .0314467     0.86   0.389    -.0345765    .0887144
             |
       _cons |   .0114595   .0245421     0.47   0.641    -.0366509    .0595699
------------------------------------------------------------------------------

      Source |       SS           df       MS      Number of obs   =     6,489
-------------+----------------------------------   F(15, 6473)     =     66.38
       Model |   890.42988        15   59.361992   Prob > F        =    0.0000
    Residual |  5788.33572     6,473  .894227672   R-squared       =    0.1333
-------------+----------------------------------   Adj R-squared   =    0.1313
       Total |   6678.7656     6,488  1.02940284   Root MSE        =    .94564

------------------------------------------------------------------------------
 bedroom_max |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
          Q2 |  -.1331979   .0289621    -4.60   0.000    -.1899731   -.0764227
          Q3 |  -.1302678   .0332515    -3.92   0.000    -.1954517   -.0650839
             |
    Zip_Code |
          3  |   .3282828   .1024642     3.20   0.001     .1274191    .5291464
          4  |   .6234009   .1064652     5.86   0.000     .4146939    .8321078
          5  |    .633058   .0839519     7.54   0.000     .4684844    .7976315
          6  |   .7933942   .1187877     6.68   0.000      .560531    1.026257
          8  |   1.065546    .093752    11.37   0.000     .8817608    1.249331
          9  |   .9726294    .090089    10.80   0.000     .7960252    1.149234
         10  |   .3127937   .0889451     3.52   0.000      .138432    .4871555
         11  |  -.1211408   .0946198    -1.28   0.200     -.306627    .0643454
         12  |   .2499899   .0868241     2.88   0.004     .0797861    .4201938
         13  |   .7552686   .0877673     8.61   0.000     .5832158    .9273214
         15  |   1.237577   .0944483    13.10   0.000     1.052427    1.422727
         17  |  -.2052487   .1095116    -1.87   0.061    -.4199276    .0094302
         18  |   .8312565   .1024527     8.11   0.000     .6304153    1.032098
             |
       _cons |   1.851044   .0812097    22.79   0.000     1.691847    2.010242
------------------------------------------------------------------------------

      Source |       SS           df       MS      Number of obs   =     6,699
-------------+----------------------------------   F(15, 6683)     =    108.90
       Model |   594.52728        15   39.635152   Prob > F        =    0.0000
    Residual |  2432.44182     6,683  .363974535   R-squared       =    0.1964
-------------+----------------------------------   Adj R-squared   =    0.1946
       Total |   3026.9691     6,698  .451921335   Root MSE        =     .6033

------------------------------------------------------------------------------
bathroom_max |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
          Q2 |  -.0975408   .0182399    -5.35   0.000    -.1332968   -.0617849
          Q3 |  -.0258572   .0209711    -1.23   0.218    -.0669672    .0152527
             |
    Zip_Code |
          3  |  -.0670433   .0626265    -1.07   0.284    -.1898112    .0557246
          4  |   .3337765   .0658341     5.07   0.000     .2047207    .4628324
          5  |   .3367002   .0511854     6.58   0.000     .2363605    .4370399
          6  |   .3804282   .0735673     5.17   0.000     .2362128    .5246436
          8  |   -.050473   .0572977    -0.88   0.378    -.1627948    .0618489
          9  |   .2062902   .0548518     3.76   0.000     .0987632    .3138171
         10  |  -.1724118   .0543593    -3.17   0.002    -.2789734   -.0658502
         11  |  -.1627058   .0573821    -2.84   0.005     -.275193   -.0502187
         12  |  -.3071762   .0529996    -5.80   0.000    -.4110724     -.20328
         13  |  -.3320778   .0537691    -6.18   0.000    -.4374824   -.2266732
         15  |   .3340656   .0581473     5.75   0.000     .2200782     .448053
         17  |   .0047035   .0659087     0.07   0.943    -.1244986    .1339055
         18  |   .7417089   .0632717    11.72   0.000     .6176761    .8657417
             |
       _cons |   1.475846   .0493839    29.89   0.000     1.379037    1.572654
------------------------------------------------------------------------------

      Source |       SS           df       MS      Number of obs   =     6,723
-------------+----------------------------------   F(15, 6707)     =     36.18
       Model |   283822207        15  18921480.5   Prob > F        =    0.0000
    Residual |  3.5078e+09     6,707  522998.387   R-squared       =    0.0749
-------------+----------------------------------   Adj R-squared   =    0.0728
       Total |  3.7916e+09     6,722  564054.208   Root MSE        =    723.19

------------------------------------------------------------------------------
        sqft |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
          Q2 |  -16.94572   21.81723    -0.78   0.437    -59.71441    25.82298
          Q3 |   5.283875   25.08306     0.21   0.833    -43.88689    54.45464
             |
    Zip_Code |
          3  |   89.74011   75.06964     1.20   0.232    -57.42024    236.9005
          4  |   95.83953   78.91488     1.21   0.225    -58.85871    250.5378
          5  |   230.3227   61.33325     3.76   0.000     110.0901    350.5554
          6  |   134.7501     88.183     1.53   0.127    -38.11661    307.6168
          8  |   57.01393   68.68293     0.83   0.407    -77.62644    191.6543
          9  |   565.8569   65.74919     8.61   0.000     436.9676    694.7462
         10  |   327.5307    65.1177     5.03   0.000     199.8793    455.1821
         11  |   149.8874   68.70716     2.18   0.029     15.19955    284.5753
         12  |   154.2361   63.52959     2.43   0.015     29.69792    278.7743
         13  |  -259.2247   64.39657    -4.03   0.000    -385.4625    -132.987
         15  |   134.9598   69.70011     1.94   0.053    -1.674564    271.5941
         17  |   497.7606   79.00023     6.30   0.000      342.895    652.6261
         18  |   333.6505   75.84382     4.40   0.000     184.9725    482.3285
             |
       _cons |   549.7471   59.19132     9.29   0.000     433.7133    665.7809
------------------------------------------------------------------------------

      Source |       SS           df       MS      Number of obs   =     6,639
-------------+----------------------------------   F(15, 6623)     =   1956.60
       Model |   544491560        15  36299437.3   Prob > F        =    0.0000
    Residual |   122871918     6,623  18552.3053   R-squared       =    0.8159
-------------+----------------------------------   Adj R-squared   =    0.8155
       Total |   667363478     6,638   100536.83   Root MSE        =    136.21

------------------------------------------------------------------------------
     assault |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
          Q2 |  -15.26454   4.140337    -3.69   0.000    -23.38093   -7.148145
          Q3 |   4.610177   4.756515     0.97   0.332    -4.714125    13.93448
             |
    Zip_Code |
          3  |  -132.9287   14.13949    -9.40   0.000    -160.6467   -105.2108
          4  |  -107.1025   14.86366    -7.21   0.000    -136.2401   -77.96497
          5  |  -153.7237   11.55234   -13.31   0.000      -176.37   -131.0773
          6  |  -186.0853   16.61015   -11.20   0.000    -218.6465    -153.524
          8  |  -270.5019   13.16797   -20.54   0.000    -296.3154   -244.6885
          9  |  -241.3723   12.45975   -19.37   0.000    -265.7974   -216.9472
         10  |  -201.1894   12.26617   -16.40   0.000     -225.235   -177.1437
         11  |  -150.0212   12.94102   -11.59   0.000    -175.3898   -124.6526
         12  |  -48.57102   11.96606    -4.06   0.000    -72.02836   -25.11369
         13  |   736.2394   12.12935    60.70   0.000     712.4619    760.0168
         15  |  -243.9681   13.12848   -18.58   0.000    -269.7042   -218.2321
         17  |  -165.2794   14.88163   -11.11   0.000    -194.4522   -136.1066
         18  |  -265.8182   14.28489   -18.61   0.000    -293.8212   -237.8152
             |
       _cons |   284.0771   11.15164    25.47   0.000     262.2163    305.9379
------------------------------------------------------------------------------

      Source |       SS           df       MS      Number of obs   =     6,705
-------------+----------------------------------   F(15, 6689)     =   2853.02
       Model |  6271684.92        15  418112.328   Prob > F        =    0.0000
    Residual |  980277.249     6,689  146.550643   R-squared       =    0.8648
-------------+----------------------------------   Adj R-squared   =    0.8645
       Total |  7251962.17     6,704   1081.7366   Root MSE        =    12.106

------------------------------------------------------------------------------
   groceries |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
          Q2 |  -.8493005   .3658778    -2.32   0.020    -1.566537   -.1320634
          Q3 |  -2.999855   .4202538    -7.14   0.000    -3.823686   -2.176023
             |
    Zip_Code |
          3  |  -81.74819   1.256655   -65.05   0.000    -84.21163   -79.28475
          4  |  -158.3009   1.321019  -119.83   0.000    -160.8905   -155.7112
          5  |   -150.996   1.026715  -147.07   0.000    -153.0087   -148.9833
          6  |  -175.6664   1.476191  -119.00   0.000    -178.5602   -172.7726
          8  |  -174.4015   1.149729  -151.69   0.000    -176.6553   -172.1477
          9  |  -179.1487   1.102222  -162.53   0.000    -181.3094    -176.988
         10  |  -164.4767   1.090094  -150.88   0.000    -166.6136   -162.3397
         11  |  -159.4645   1.150147  -138.65   0.000    -161.7191   -157.2098
         12  |  -164.1424   1.063482  -154.34   0.000    -166.2272   -162.0576
         13  |  -165.0309   1.077991  -153.09   0.000    -167.1442   -162.9177
         15  |  -182.9354   1.170967  -156.23   0.000    -185.2309     -180.64
         17  |  -131.9585   1.322511   -99.78   0.000     -134.551   -129.3659
         18  |  -175.7163   1.269601  -138.40   0.000    -178.2051   -173.2275
             |
       _cons |   185.4586   .9908756   187.17   0.000     183.5161     187.401
------------------------------------------------------------------------------

      Source |       SS           df       MS      Number of obs   =     6,723
-------------+----------------------------------   F(15, 6707)     =    173.28
       Model |  61.9707945        15   4.1313863   Prob > F        =    0.0000
    Residual |  159.906312     6,707  .023841704   R-squared       =    0.2793
-------------+----------------------------------   Adj R-squared   =    0.2777
       Total |  221.877106     6,722  .033007603   Root MSE        =    .15441

------------------------------------------------------------------------------
hispanicsh~e |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
          Q2 |   .0217708   .0046582     4.67   0.000     .0126392    .0309023
          Q3 |  -.0308699   .0053555    -5.76   0.000    -.0413683   -.0203714
             |
    Zip_Code |
          3  |  -.0188917   .0160281    -1.18   0.239    -.0503119    .0125286
          4  |   .0473505   .0168491     2.81   0.005     .0143209    .0803802
          5  |  -.0335151   .0130953    -2.56   0.011     -.059186   -.0078442
          6  |   .1013226    .018828     5.38   0.000     .0644138    .1382314
          8  |  -.0428361   .0146645    -2.92   0.003    -.0715832    -.014089
          9  |  -.0482811   .0140381    -3.44   0.001    -.0758003   -.0207619
         10  |  -.0063248   .0139033    -0.45   0.649    -.0335796    .0209301
         11  |  -.0430705   .0146697    -2.94   0.003    -.0718278   -.0143133
         12  |  -.0164394   .0135642    -1.21   0.226    -.0430295    .0101508
         13  |   .2561673   .0137493    18.63   0.000     .2292143    .2831204
         15  |   .1425622   .0148817     9.58   0.000     .1133894    .1717351
         17  |   .1079284   .0168673     6.40   0.000     .0748631    .1409938
         18  |   .0340453   .0161934     2.10   0.036     .0023011    .0657896
             |
       _cons |   .0882876   .0126379     6.99   0.000     .0635132     .113062
------------------------------------------------------------------------------

      Source |       SS           df       MS      Number of obs   =     6,723
-------------+----------------------------------   F(15, 6707)     =    320.02
       Model |  247.275005        15  16.4850004   Prob > F        =    0.0000
    Residual |  345.492069     6,707  .051512162   R-squared       =    0.4172
-------------+----------------------------------   Adj R-squared   =    0.4159
       Total |  592.767074     6,722  .088183141   Root MSE        =    .22696

------------------------------------------------------------------------------
  blackshare |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
          Q2 |   .0262831   .0068471     3.84   0.000     .0128607    .0397055
          Q3 |   .0659054    .007872     8.37   0.000     .0504738     .081337
             |
    Zip_Code |
          3  |   .3369309   .0235597    14.30   0.000     .2907465    .3831153
          4  |   .1076132   .0247664     4.35   0.000     .0590631    .1561633
          5  |   .1761165   .0192487     9.15   0.000     .1383829      .21385
          6  |   .2581118   .0276751     9.33   0.000     .2038598    .3123639
          8  |   .0671878   .0215553     3.12   0.002     .0249327     .109443
          9  |   .0101118   .0206346     0.49   0.624    -.0303385    .0505621
         10  |   .0944774   .0204364     4.62   0.000     .0544156    .1345391
         11  |   .0478577   .0215629     2.22   0.026     .0055876    .0901278
         12  |   .4041552    .019938    20.27   0.000     .3650704    .4432399
         13  |   .6082398   .0202101    30.10   0.000     .5686217    .6478579
         15  |   .3962742   .0218745    18.12   0.000     .3533932    .4391552
         17  |   .0525871   .0247932     2.12   0.034     .0039845    .1011897
         18  |  -.0181092   .0238026    -0.76   0.447    -.0647699    .0285515
             |
       _cons |  -.0028748   .0185765    -0.15   0.877    -.0392906    .0335409
------------------------------------------------------------------------------

      Source |       SS           df       MS      Number of obs   =     6,723
-------------+----------------------------------   F(15, 6707)     =    461.69
       Model |  275.199483        15  18.3466322   Prob > F        =    0.0000
    Residual |  266.523792     6,707  .039738153   R-squared       =    0.5080
-------------+----------------------------------   Adj R-squared   =    0.5069
       Total |  541.723274     6,722  .080589597   Root MSE        =    .19934

------------------------------------------------------------------------------
  whiteshare |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
          Q2 |  -.0385776   .0060139    -6.41   0.000    -.0503667   -.0267886
          Q3 |  -.0461426   .0069141    -6.67   0.000    -.0596964   -.0325888
             |
    Zip_Code |
          3  |  -.3490152   .0206927   -16.87   0.000    -.3895795   -.3084508
          4  |  -.1106536   .0217527    -5.09   0.000    -.1532958   -.0680115
          5  |  -.1564535   .0169063    -9.25   0.000    -.1895953   -.1233117
          6  |  -.2327568   .0243074    -9.58   0.000     -.280407   -.1851066
          8  |  -.0709956   .0189323    -3.75   0.000    -.1081088   -.0338823
          9  |  -.1227972   .0181236    -6.78   0.000    -.1583252   -.0872693
         10  |  -.0689934   .0179495    -3.84   0.000    -.1041801   -.0338066
         11  |  -.0342983   .0189389    -1.81   0.070    -.0714246    .0028281
         12  |  -.3897914   .0175118   -22.26   0.000      -.42412   -.3554628
         13  |  -.6599666   .0177507   -37.18   0.000    -.6947637   -.6251695
         15  |  -.4953153   .0192126   -25.78   0.000    -.5329782   -.4576525
         17  |  -.1278014   .0217762    -5.87   0.000    -.1704896   -.0851131
         18  |   .0486766   .0209061     2.33   0.020     .0076939    .0896593
             |
       _cons |   .9067571   .0163159    55.57   0.000     .8747727    .9387415
------------------------------------------------------------------------------

      Source |       SS           df       MS      Number of obs   =     6,723
-------------+----------------------------------   F(15, 6707)     =    469.04
       Model |  164.831592        15  10.9887728   Prob > F        =    0.0000
    Residual |  157.132674     6,707  .023428161   R-squared       =    0.5120
-------------+----------------------------------   Adj R-squared   =    0.5109
       Total |  321.964266     6,722  .047897094   Root MSE        =    .15306

------------------------------------------------------------------------------
     povrate |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
          Q2 |   .0474659   .0046176    10.28   0.000     .0384139    .0565179
          Q3 |   .0260077   .0053088     4.90   0.000     .0156007    .0364147
             |
    Zip_Code |
          3  |   .1079068   .0158885     6.79   0.000     .0767603    .1390533
          4  |   .0908477   .0167024     5.44   0.000     .0581058    .1235897
          5  |   .0744825   .0129812     5.74   0.000     .0490352    .0999298
          6  |    .141174    .018664     7.56   0.000     .1045867    .1777613
          8  |   .5155979   .0145368    35.47   0.000     .4871013    .5440946
          9  |   .4751522   .0139158    34.14   0.000     .4478728    .5024317
         10  |   .2221216   .0137822    16.12   0.000     .1951041     .249139
         11  |   .1288543   .0145419     8.86   0.000     .1003476    .1573611
         12  |   .2488139   .0134461    18.50   0.000     .2224553    .2751724
         13  |   .3717579   .0136296    27.28   0.000     .3450396    .3984761
         15  |    .041039    .014752     2.78   0.005     .0121203    .0699577
         17  |   .1781507   .0167204    10.65   0.000     .1453734    .2109281
         18  |   .0195065   .0160524     1.22   0.224    -.0119613    .0509742
             |
       _cons |   .0337532   .0125279     2.69   0.007     .0091946    .0583118
------------------------------------------------------------------------------

      Source |       SS           df       MS      Number of obs   =     6,720
-------------+----------------------------------   F(15, 6704)     =    225.98
       Model |  16.6452153        15  1.10968102   Prob > F        =    0.0000
    Residual |  32.9206262     6,704  .004910595   R-squared       =    0.3358
-------------+----------------------------------   Adj R-squared   =    0.3343
       Total |  49.5658415     6,719  .007376967   Root MSE        =    .07008

------------------------------------------------------------------------------
  unemployed |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
          Q2 |   .0023233   .0021145     1.10   0.272    -.0018218    .0064684
          Q3 |   .0015164   .0024305     0.62   0.533    -.0032482     .006281
             |
    Zip_Code |
          3  |   .0427237   .0072742     5.87   0.000     .0284641    .0569834
          4  |   .0175744   .0076468     2.30   0.022     .0025843    .0325644
          5  |   .0278821   .0059434     4.69   0.000     .0162312    .0395331
          6  |   .0547402   .0085448     6.41   0.000     .0379895    .0714908
          8  |   .0184645   .0066553     2.77   0.006     .0054181     .031511
          9  |   .0044235    .006371     0.69   0.488    -.0080658    .0169127
         10  |   .0332268   .0063099     5.27   0.000     .0208575    .0455961
         11  |   .0013149   .0066576     0.20   0.843    -.0117362     .014366
         12  |   .0831422   .0061559    13.51   0.000     .0710746    .0952099
         13  |   .1740743     .00624    27.90   0.000      .161842    .1863066
         15  |   .0577233   .0067539     8.55   0.000     .0444836     .070963
         17  |   .0242514   .0076551     3.17   0.002      .009245    .0392578
         18  |   .0020516   .0073492     0.28   0.780     -.012355    .0164583
             |
       _cons |   .0387715   .0057355     6.76   0.000      .027528     .050015
------------------------------------------------------------------------------

      Source |       SS           df       MS      Number of obs   =     6,723
-------------+----------------------------------   F(15, 6707)     =    356.36
       Model |  75.2373739        15  5.01582492   Prob > F        =    0.0000
    Residual |  94.4019265     6,707  .014075134   R-squared       =    0.4435
-------------+----------------------------------   Adj R-squared   =    0.4423
       Total |    169.6393     6,722  .025236433   Root MSE        =    .11864

------------------------------------------------------------------------------
     college |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
          Q2 |   -.010602   .0035791    -2.96   0.003    -.0176182   -.0035858
          Q3 |   .0130826   .0041149     3.18   0.001     .0050162    .0211491
             |
    Zip_Code |
          3  |  -.1723976   .0123152   -14.00   0.000    -.1965392   -.1482559
          4  |  -.1592861    .012946   -12.30   0.000    -.1846644   -.1339079
          5  |  -.0846129   .0100617    -8.41   0.000    -.1043371   -.0648888
          6  |  -.2122646   .0144664   -14.67   0.000    -.2406234   -.1839059
          8  |   .0080036   .0112674     0.71   0.478    -.0140841    .0300913
          9  |  -.1632889   .0107862   -15.14   0.000    -.1844332   -.1421446
         10  |  -.1091527   .0106826   -10.22   0.000    -.1300939   -.0882115
         11  |   .0223694   .0112714     1.98   0.047     .0002739    .0444649
         12  |  -.1887339    .010422   -18.11   0.000    -.2091644   -.1683035
         13  |  -.3569846   .0105643   -33.79   0.000    -.3776939   -.3362753
         15  |  -.2972911   .0114343   -26.00   0.000    -.3197059   -.2748762
         17  |  -.0580328     .01296    -4.48   0.000    -.0834385   -.0326272
         18  |  -.1252296   .0124422   -10.06   0.000    -.1496202    -.100839
             |
       _cons |   .4182817   .0097103    43.08   0.000     .3992464    .4373171
------------------------------------------------------------------------------

. 
. mat list B

B[38,3]
             c1          c2          c3
 r1  -6.8259406   2.7869152   15.908902
 r2   1.3423267   .49476586   .56882767
 r3   1.2315549   1.2118077   2.7121036
 r4   .61470828   .22657425    .2604903
 r5  -1.6552654   3.5886161    4.197974
 r6   .71428608   .26327746   .30268763
 r7   5.4501381  -.31289469  -.27889138
 r8   .10373636   .03830898   .04397436
 r9   .04987394  -.04860285  -.10179368
r10   .02875457    .0105986   .01218511
r11  -.01338186  -.00814801   .02816018
r12   .02680992   .00988182   .01136104
r13   .95204841   .02410484   .05877511
r14     .036169   .01333147   .01532706
r15    .0114595   .03264602   .01485839
r16   .02454214   .00904594   .01040004
r17   1.8510444  -.13319791  -.13026776
r18   .08120971   .02896207   .03325148
r19   1.4758456  -.09754083  -.02585722
r20   .04938387   .01823986   .02097105
r21   549.74709  -16.945719   5.2838753
r22   59.191321   21.817226    25.08306
r23   284.07712   -15.26454   4.6101766
r24   11.151637   4.1403371    4.756515
r25   185.45857  -.84930047  -2.9998548
r26   .99087557   .36587776   .42025375
r27   .08828763    .0217708  -.03086985
r28   .01263795    .0046582   .00535549
r29  -.00287482   .02628307   .06590541
r30   .01857645   .00684706     .007872
r31   .90675712  -.03857763  -.04614259
r32   .01631592   .00601386   .00691408
r33   .03375318   .04746591   .02600772
r34   .01252786   .00461762   .00530884
r35   .03877151   .00232328    .0015164
r36   .00573555   .00211449   .00243051
r37   .41828173  -.01060202   .01308264
r38   .00971033   .00357911   .00411487

. 
. preserve

. clear

. svmat B
number of observations will be reset to 38
Press any key to continue, or Break to abort
number of observations (_N) was 0, now 38

. 
. 
. forvalues j = 1/`quartiles'{
  2.         rename B`j' Q`j'
  3.         format %9.2fc Q`j'
  4. }

. 
. export delimited using "../views/descriptive_RSEI_ttest.csv", replace
(note: file ../views/descriptive_RSEI_ttest.csv not found)
file ../views/descriptive_RSEI_ttest.csv saved

. 
. restore

. 
. *Needs to be handcoded
. preserve

. egen listings_zip_bin = count(Address), by (Zip_Code quartileZIP_property)

. egen listings_zip = count(Address), by (Zip_Code)

. gen share_listings=listings_zip_bin/listings_zip

. 
. 
. collapse (median) share_listings, by(quartileZIP_property Zip_Code)

. 
. forvalues j = 2/`quartiles'{
  2.         sum  share_listings if quartileZIP_property==`j'
  3. }       

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
share_list~s |         14     .263065    .1222494   .0298507         .5

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
share_list~s |         14    .4927243    .2119014   .0192308   .9402985

. 
. tab quartileZIP_property, gen(Q)

            Quartile Within Zip Toxic |
                        Concentration |      Freq.     Percent        Cum.
--------------------------------------+-----------------------------------
  0-25 Within Zip Toxic Concentration |         14       33.33       33.33
 25-75 Within Zip Toxic Concentration |         14       33.33       66.67
75-100 Within Zip Toxic Concentration |         14       33.33      100.00
--------------------------------------+-----------------------------------
                                Total |         42      100.00

. reg share_listings Q2 Q3 i.Zip_Code

      Source |       SS           df       MS      Number of obs   =        42
-------------+----------------------------------   F(15, 26)       =      1.01
       Model |  .536003729        15  .035733582   Prob > F        =    0.4764
    Residual |  .921384688        26  .035437873   R-squared       =    0.3678
-------------+----------------------------------   Adj R-squared   =    0.0030
       Total |  1.45738842        41  .035546059   Root MSE        =    .18825

------------------------------------------------------------------------------
share_list~s |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-------------+----------------------------------------------------------------
          Q2 |   .2296594   .0711516     3.23   0.003     .0834051    .3759136
          Q3 |  -.0188542   .0711516    -0.26   0.793    -.1651085       .1274
             |
    Zip_Code |
          3  |   9.31e-09   .1537051     0.00   1.000    -.3159453    .3159453
          4  |  -5.59e-09   .1537051    -0.00   1.000    -.3159453    .3159453
          5  |   4.35e-09   .1537051     0.00   1.000    -.3159453    .3159453
          6  |   9.31e-09   .1537051     0.00   1.000    -.3159453    .3159453
          8  |   1.43e-08   .1537051     0.00   1.000    -.3159453    .3159453
          9  |  -6.21e-10   .1537051    -0.00   1.000    -.3159453    .3159453
         10  |   9.31e-09   .1537051     0.00   1.000    -.3159453    .3159453
         11  |   9.31e-09   .1537051     0.00   1.000    -.3159453    .3159453
         12  |   9.31e-09   .1537051     0.00   1.000    -.3159453    .3159453
         13  |   1.43e-08   .1537051     0.00   1.000    -.3159453    .3159453
         15  |   4.35e-09   .1537051     0.00   1.000    -.3159453    .3159453
         17  |   6.21e-10   .1537051     0.00   1.000    -.3159453    .3159453
         18  |   4.35e-09   .1537051     0.00   1.000    -.3159453    .3159453
             |
       _cons |    .263065   .1161901     2.26   0.032     .0242328    .5018971
------------------------------------------------------------------------------

. restore

. 
. *end
. 
end of do-file
